CREATE TABLE `receipt_info` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `jiaoyi_id` bigint(20) unsigned DEFAULT NULL COMMENT '交易id',
  `operater_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `operater_usercode` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `user_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户code',
  `user_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户name',
  `dept_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '部门ID',
  `dept_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '部门编码',
  `dept_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '部门名称',
  `superior_dept_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '父部门名称',
  `area_id` bigint(20) DEFAULT NULL COMMENT '区域id',
  `city_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '要户所在城市',
  `bigarea_id` bigint(22) DEFAULT NULL,
  `bigarea_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '大战区',
  `area_manager` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '区域经理',
  `group_manager` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '组经理名称',
  `receipt_share` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '开单分享',
  `receipt_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '开单类型,二手,租赁,新房',
  `receipt_commission` float(50,2) DEFAULT NULL COMMENT '成交佣金',
  `receipt_price` float(50,2) DEFAULT NULL COMMENT '成交价格',
  `rate` float(50,2) DEFAULT NULL COMMENT '费率',
  `receipt_source` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '客户来源',
  `receipt_identifier` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '交易编号',
  `ding_send_success` bit(1) DEFAULT b'0' COMMENT 'ding群消息是否发送成功',
  `receipt_commission_alias` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '成交佣金别名',
  `hide_commission_flag` tinyint(1) DEFAULT NULL COMMENT '隐藏佣金标志0不隐藏 1 隐藏',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `mendian_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '门店名称',
  `mendian_id` bigint(20) DEFAULT NULL COMMENT '门店id',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_create_time` (`create_time`) USING BTREE,
  KEY `idx_dept_code` (`dept_code`,`receipt_type`) USING BTREE,
  KEY `idx_user_code` (`user_code`,`receipt_type`) USING BTREE,
  KEY `idx_operater_usercode_receipt_type` (`operater_usercode`,`receipt_type`,`create_time`) USING BTREE,
  KEY `idx_dept_id_create_time` (`dept_id`,`create_time`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=19483 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='战报详情';


CREATE TABLE `department_time` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `dept_id` int(11) DEFAULT NULL,
  `depT_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `dept_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '员工编号',
  `dept_all_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `dept_all_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `property` int(11) DEFAULT NULL,
  `parent_dept_id` int(11) DEFAULT NULL,
  `parent_dept_name` int(11) DEFAULT NULL,
  `dept_start_time` date DEFAULT NULL,
  `dept_end_time` date DEFAULT NULL,
  `hiredate` datetime DEFAULT NULL,
  `deptid_zhanqu` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_department_parent` (`parent_dept_id`),
  KEY `idx_departtime_id` (`dept_id`,`property`),
  KEY `idx_parentcomplex` (`parent_dept_id`,`dept_start_time`,`dept_end_time`) USING BTREE,
  KEY `IDX_DEPTCODE` (`depT_code`)
) ENGINE=InnoDB AUTO_INCREMENT=16385 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;	



